package com.jyh.db.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class JyhOrderExample {
    /**
     * jyh_order
     */
    protected String orderByClause;

    /**
     * jyh_order
     */
    protected boolean distinct;

    /**
     * jyh_order
     */
    protected List<Criteria> oredCriteria;

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public JyhOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-17
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * jyh_order 2017-10-17
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIDIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIDIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIDEqualTo(Integer value) {
            addCriterion("ID =", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThan(Integer value) {
            addCriterion("ID >", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThan(Integer value) {
            addCriterion("ID <", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "ID");
            return (Criteria) this;
        }

        public Criteria andIDIn(List<Integer> values) {
            addCriterion("ID in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "ID");
            return (Criteria) this;
        }

        public Criteria andIDBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andIDNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "ID");
            return (Criteria) this;
        }

        public Criteria andOrderNOIsNull() {
            addCriterion("orderNO is null");
            return (Criteria) this;
        }

        public Criteria andOrderNOIsNotNull() {
            addCriterion("orderNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNOEqualTo(String value) {
            addCriterion("orderNO =", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNONotEqualTo(String value) {
            addCriterion("orderNO <>", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOGreaterThan(String value) {
            addCriterion("orderNO >", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOGreaterThanOrEqualTo(String value) {
            addCriterion("orderNO >=", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOLessThan(String value) {
            addCriterion("orderNO <", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOLessThanOrEqualTo(String value) {
            addCriterion("orderNO <=", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOLike(String value) {
            addCriterion("orderNO like", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNONotLike(String value) {
            addCriterion("orderNO not like", value, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOIn(List<String> values) {
            addCriterion("orderNO in", values, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNONotIn(List<String> values) {
            addCriterion("orderNO not in", values, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNOBetween(String value1, String value2) {
            addCriterion("orderNO between", value1, value2, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderNONotBetween(String value1, String value2) {
            addCriterion("orderNO not between", value1, value2, "orderNO");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("orderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("orderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(Date value) {
            addCriterion("orderTime =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(Date value) {
            addCriterion("orderTime <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(Date value) {
            addCriterion("orderTime >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("orderTime >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(Date value) {
            addCriterion("orderTime <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("orderTime <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<Date> values) {
            addCriterion("orderTime in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<Date> values) {
            addCriterion("orderTime not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(Date value1, Date value2) {
            addCriterion("orderTime between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("orderTime not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andUserNOIsNull() {
            addCriterion("userNO is null");
            return (Criteria) this;
        }

        public Criteria andUserNOIsNotNull() {
            addCriterion("userNO is not null");
            return (Criteria) this;
        }

        public Criteria andUserNOEqualTo(String value) {
            addCriterion("userNO =", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNONotEqualTo(String value) {
            addCriterion("userNO <>", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOGreaterThan(String value) {
            addCriterion("userNO >", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOGreaterThanOrEqualTo(String value) {
            addCriterion("userNO >=", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOLessThan(String value) {
            addCriterion("userNO <", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOLessThanOrEqualTo(String value) {
            addCriterion("userNO <=", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOLike(String value) {
            addCriterion("userNO like", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNONotLike(String value) {
            addCriterion("userNO not like", value, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOIn(List<String> values) {
            addCriterion("userNO in", values, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNONotIn(List<String> values) {
            addCriterion("userNO not in", values, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNOBetween(String value1, String value2) {
            addCriterion("userNO between", value1, value2, "userNO");
            return (Criteria) this;
        }

        public Criteria andUserNONotBetween(String value1, String value2) {
            addCriterion("userNO not between", value1, value2, "userNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOIsNull() {
            addCriterion("typeNO is null");
            return (Criteria) this;
        }

        public Criteria andTypeNOIsNotNull() {
            addCriterion("typeNO is not null");
            return (Criteria) this;
        }

        public Criteria andTypeNOEqualTo(String value) {
            addCriterion("typeNO =", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNONotEqualTo(String value) {
            addCriterion("typeNO <>", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOGreaterThan(String value) {
            addCriterion("typeNO >", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOGreaterThanOrEqualTo(String value) {
            addCriterion("typeNO >=", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOLessThan(String value) {
            addCriterion("typeNO <", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOLessThanOrEqualTo(String value) {
            addCriterion("typeNO <=", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOLike(String value) {
            addCriterion("typeNO like", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNONotLike(String value) {
            addCriterion("typeNO not like", value, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOIn(List<String> values) {
            addCriterion("typeNO in", values, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNONotIn(List<String> values) {
            addCriterion("typeNO not in", values, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNOBetween(String value1, String value2) {
            addCriterion("typeNO between", value1, value2, "typeNO");
            return (Criteria) this;
        }

        public Criteria andTypeNONotBetween(String value1, String value2) {
            addCriterion("typeNO not between", value1, value2, "typeNO");
            return (Criteria) this;
        }

        public Criteria andReviewTimeIsNull() {
            addCriterion("reviewTime is null");
            return (Criteria) this;
        }

        public Criteria andReviewTimeIsNotNull() {
            addCriterion("reviewTime is not null");
            return (Criteria) this;
        }

        public Criteria andReviewTimeEqualTo(Date value) {
            addCriterion("reviewTime =", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeNotEqualTo(Date value) {
            addCriterion("reviewTime <>", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeGreaterThan(Date value) {
            addCriterion("reviewTime >", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("reviewTime >=", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeLessThan(Date value) {
            addCriterion("reviewTime <", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeLessThanOrEqualTo(Date value) {
            addCriterion("reviewTime <=", value, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeIn(List<Date> values) {
            addCriterion("reviewTime in", values, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeNotIn(List<Date> values) {
            addCriterion("reviewTime not in", values, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeBetween(Date value1, Date value2) {
            addCriterion("reviewTime between", value1, value2, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andReviewTimeNotBetween(Date value1, Date value2) {
            addCriterion("reviewTime not between", value1, value2, "reviewTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("endTime is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("endTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("endTime =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("endTime <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("endTime >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("endTime >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("endTime <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("endTime <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("endTime in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("endTime not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("endTime between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("endTime not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andPutBankNOIsNull() {
            addCriterion("putBankNO is null");
            return (Criteria) this;
        }

        public Criteria andPutBankNOIsNotNull() {
            addCriterion("putBankNO is not null");
            return (Criteria) this;
        }

        public Criteria andPutBankNOEqualTo(String value) {
            addCriterion("putBankNO =", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNONotEqualTo(String value) {
            addCriterion("putBankNO <>", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOGreaterThan(String value) {
            addCriterion("putBankNO >", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOGreaterThanOrEqualTo(String value) {
            addCriterion("putBankNO >=", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOLessThan(String value) {
            addCriterion("putBankNO <", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOLessThanOrEqualTo(String value) {
            addCriterion("putBankNO <=", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOLike(String value) {
            addCriterion("putBankNO like", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNONotLike(String value) {
            addCriterion("putBankNO not like", value, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOIn(List<String> values) {
            addCriterion("putBankNO in", values, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNONotIn(List<String> values) {
            addCriterion("putBankNO not in", values, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNOBetween(String value1, String value2) {
            addCriterion("putBankNO between", value1, value2, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNONotBetween(String value1, String value2) {
            addCriterion("putBankNO not between", value1, value2, "putBankNO");
            return (Criteria) this;
        }

        public Criteria andPutBankNameIsNull() {
            addCriterion("putBankName is null");
            return (Criteria) this;
        }

        public Criteria andPutBankNameIsNotNull() {
            addCriterion("putBankName is not null");
            return (Criteria) this;
        }

        public Criteria andPutBankNameEqualTo(String value) {
            addCriterion("putBankName =", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameNotEqualTo(String value) {
            addCriterion("putBankName <>", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameGreaterThan(String value) {
            addCriterion("putBankName >", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("putBankName >=", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameLessThan(String value) {
            addCriterion("putBankName <", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameLessThanOrEqualTo(String value) {
            addCriterion("putBankName <=", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameLike(String value) {
            addCriterion("putBankName like", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameNotLike(String value) {
            addCriterion("putBankName not like", value, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameIn(List<String> values) {
            addCriterion("putBankName in", values, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameNotIn(List<String> values) {
            addCriterion("putBankName not in", values, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameBetween(String value1, String value2) {
            addCriterion("putBankName between", value1, value2, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankNameNotBetween(String value1, String value2) {
            addCriterion("putBankName not between", value1, value2, "putBankName");
            return (Criteria) this;
        }

        public Criteria andPutBankCardIsNull() {
            addCriterion("putBankCard is null");
            return (Criteria) this;
        }

        public Criteria andPutBankCardIsNotNull() {
            addCriterion("putBankCard is not null");
            return (Criteria) this;
        }

        public Criteria andPutBankCardEqualTo(String value) {
            addCriterion("putBankCard =", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardNotEqualTo(String value) {
            addCriterion("putBankCard <>", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardGreaterThan(String value) {
            addCriterion("putBankCard >", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardGreaterThanOrEqualTo(String value) {
            addCriterion("putBankCard >=", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardLessThan(String value) {
            addCriterion("putBankCard <", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardLessThanOrEqualTo(String value) {
            addCriterion("putBankCard <=", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardLike(String value) {
            addCriterion("putBankCard like", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardNotLike(String value) {
            addCriterion("putBankCard not like", value, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardIn(List<String> values) {
            addCriterion("putBankCard in", values, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardNotIn(List<String> values) {
            addCriterion("putBankCard not in", values, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardBetween(String value1, String value2) {
            addCriterion("putBankCard between", value1, value2, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutBankCardNotBetween(String value1, String value2) {
            addCriterion("putBankCard not between", value1, value2, "putBankCard");
            return (Criteria) this;
        }

        public Criteria andPutStateIsNull() {
            addCriterion("putState is null");
            return (Criteria) this;
        }

        public Criteria andPutStateIsNotNull() {
            addCriterion("putState is not null");
            return (Criteria) this;
        }

        public Criteria andPutStateEqualTo(Integer value) {
            addCriterion("putState =", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateNotEqualTo(Integer value) {
            addCriterion("putState <>", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateGreaterThan(Integer value) {
            addCriterion("putState >", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("putState >=", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateLessThan(Integer value) {
            addCriterion("putState <", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateLessThanOrEqualTo(Integer value) {
            addCriterion("putState <=", value, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateIn(List<Integer> values) {
            addCriterion("putState in", values, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateNotIn(List<Integer> values) {
            addCriterion("putState not in", values, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateBetween(Integer value1, Integer value2) {
            addCriterion("putState between", value1, value2, "putState");
            return (Criteria) this;
        }

        public Criteria andPutStateNotBetween(Integer value1, Integer value2) {
            addCriterion("putState not between", value1, value2, "putState");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andScoreIsNull() {
            addCriterion("score is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("score is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(String value) {
            addCriterion("score =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(String value) {
            addCriterion("score <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(String value) {
            addCriterion("score >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(String value) {
            addCriterion("score >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(String value) {
            addCriterion("score <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(String value) {
            addCriterion("score <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLike(String value) {
            addCriterion("score like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotLike(String value) {
            addCriterion("score not like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<String> values) {
            addCriterion("score in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<String> values) {
            addCriterion("score not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(String value1, String value2) {
            addCriterion("score between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(String value1, String value2) {
            addCriterion("score not between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIsNull() {
            addCriterion("operationTime is null");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIsNotNull() {
            addCriterion("operationTime is not null");
            return (Criteria) this;
        }

        public Criteria andOperationTimeEqualTo(Date value) {
            addCriterion("operationTime =", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotEqualTo(Date value) {
            addCriterion("operationTime <>", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeGreaterThan(Date value) {
            addCriterion("operationTime >", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("operationTime >=", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeLessThan(Date value) {
            addCriterion("operationTime <", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeLessThanOrEqualTo(Date value) {
            addCriterion("operationTime <=", value, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeIn(List<Date> values) {
            addCriterion("operationTime in", values, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotIn(List<Date> values) {
            addCriterion("operationTime not in", values, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeBetween(Date value1, Date value2) {
            addCriterion("operationTime between", value1, value2, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperationTimeNotBetween(Date value1, Date value2) {
            addCriterion("operationTime not between", value1, value2, "operationTime");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIsNull() {
            addCriterion("operatorName is null");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIsNotNull() {
            addCriterion("operatorName is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorNameEqualTo(String value) {
            addCriterion("operatorName =", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotEqualTo(String value) {
            addCriterion("operatorName <>", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameGreaterThan(String value) {
            addCriterion("operatorName >", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameGreaterThanOrEqualTo(String value) {
            addCriterion("operatorName >=", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLessThan(String value) {
            addCriterion("operatorName <", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLessThanOrEqualTo(String value) {
            addCriterion("operatorName <=", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameLike(String value) {
            addCriterion("operatorName like", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotLike(String value) {
            addCriterion("operatorName not like", value, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameIn(List<String> values) {
            addCriterion("operatorName in", values, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotIn(List<String> values) {
            addCriterion("operatorName not in", values, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameBetween(String value1, String value2) {
            addCriterion("operatorName between", value1, value2, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNameNotBetween(String value1, String value2) {
            addCriterion("operatorName not between", value1, value2, "operatorName");
            return (Criteria) this;
        }

        public Criteria andOperatorNOIsNull() {
            addCriterion("operatorNO is null");
            return (Criteria) this;
        }

        public Criteria andOperatorNOIsNotNull() {
            addCriterion("operatorNO is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorNOEqualTo(String value) {
            addCriterion("operatorNO =", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNONotEqualTo(String value) {
            addCriterion("operatorNO <>", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOGreaterThan(String value) {
            addCriterion("operatorNO >", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOGreaterThanOrEqualTo(String value) {
            addCriterion("operatorNO >=", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOLessThan(String value) {
            addCriterion("operatorNO <", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOLessThanOrEqualTo(String value) {
            addCriterion("operatorNO <=", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOLike(String value) {
            addCriterion("operatorNO like", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNONotLike(String value) {
            addCriterion("operatorNO not like", value, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOIn(List<String> values) {
            addCriterion("operatorNO in", values, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNONotIn(List<String> values) {
            addCriterion("operatorNO not in", values, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNOBetween(String value1, String value2) {
            addCriterion("operatorNO between", value1, value2, "operatorNO");
            return (Criteria) this;
        }

        public Criteria andOperatorNONotBetween(String value1, String value2) {
            addCriterion("operatorNO not between", value1, value2, "operatorNO");
            return (Criteria) this;
        }
    }

    /**
     * jyh_order
     *
     * @mbggenerated do_not_delete_during_merge 2017-10-17
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * jyh_order 2017-10-17
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}